--delete company
DELETE FROM [dbo].[z_png_webform_company] WHERE company_code = '2245' and country = 'MY'
DELETE FROM [dbo].[z_png_webform_company] WHERE company_code = '2328' and country = 'MY'

--insert company
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'293', N'PROCTER & GAMBLE (GUANGZHOU) LTD.', N'P&G (Guangzhou) Ltd.', N'Guangzhou', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'324', N'GILLETTE (SHANGHAI) LTD', N'Gillette (Shanghai) Ltd', N'Shanghai', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'326', N'DURACELL (CHINA) LTD', N'Duracell (China) Ltd', N'DongGuan GuangDong', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'581', N'PROCTER & GAMBLE (CHENGDU) LTD.', N'P&G (Chengdu) LTD.', N'Chengdu', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'582', N'PROCTER & GAMBLE DETERGENT (BEIJING) LTD .', N'P&G Detergent(Beijing)Ltd', N'Beijing', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'583', N'PROCTER & GAMBLE (GUANGZHOU) LTD. TIANJIN BRANCH COMPANY', N'P&G(Guangzhou)Ltd.Tianjin', N'Tianjin', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'676', N'PROCTER & GAMBLE MANUFACTURING (TIANJIN) CO., LTD.', N'P&G Mfg (Tianjin) Co, Ltd', N'Tianjin', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'692', N'PROCTER & GAMBLE TECHNOLOGY (BEIJING) CO. LTD.', N'P&G Tech (Beijing) Co LTD', N'Beijing', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'905', N'PROCTER & GAMBLE (SHANGHAI) INTERNATIONAL TRADE COMPANY LTD.', N'P&G Sh Intl Trade Co Ltd', N'Shanghai', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'986', N'PROCTER & GAMBLE (GUANGZHOU) LTD. TIANJIN XIQING BRANCH CO', N'P&GGzLtdTianjinXiqingBrCo', N'Guangzhou', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2008', N'BRAUN (SHANGHAI) CO., LTD.', N'Braun (Shanghai) Co., Ltd', N'Minhang, Shanghai', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2273', N'PROCTER & GAMBLE (JIANGSU) LTD', N'P&G (Jiangsu) Ltd', N'Taicang', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2294', N'PROCTER & GAMBLE (CHINA) SALES CO., LTD.', N'P&G (China) Sales Co. Ltd', N'Shanghai', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2338', N'PROCTER & GAMBLE (GUANGZHOU) CONSUMER PRODUCTS CO., LTD.', N'P&G (Guangzhou) Consumer', N'Guangzhou', N'CN', N'CHINA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'600', N'PROCTER & GAMBLE BULGARIA EOOD', N'P&G Bulgaria EOOD', N'Sofia', N'RO', N'BULGARIA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'575', N'PROCTER & GAMBLE MARKETING ROMANIA SRL', N'P&G Marketing Romania SRL', N'Bucharest', N'RO', N'ROMANIA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'593', N'DETERGENTI SA', N'Detergenti S.A.', N'Timisoara', N'RO', N'ROMANIA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'943', N'PROCTER & GAMBLE DISTRIBUTION SRL', N'P&G Distribution SRL', N'Bucharest', N'RO', N'ROMANIA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'605', N'PROCTER AND GAMBLE MARKETING AND SERVICES D.O.O. BEOGRAD', N'P&G Mktg&Serv doo Beograd', N'Novi Beograd', N'RO', N'SERBIA');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'403', N'PROCTER & GAMBLE PHILIPPINES, INC.', N'P&G Philippines, Inc.', N'Makati', N'PH', N'Philippines');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'753', N'PROCTER & GAMBLE INTERNATIONAL OPERATIONS SA-ROHQ', N'P&G INTL OPS SA-ROHQ', N'Makati', N'PH', N'Philippines');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'829', N'PROCTER & GAMBLE DISTRIBUTING (PHILIPPINES), INC.', N'P&G Distributing(PH),Inc.', N'Makati', N'PH', N'Philippines');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'604', N'PT PROCTER & GAMBLE HOME PRODUCTS INDONESIA', N'PT P&G HomeProd Indonesia', N'Jakarta Pusat', N'ID', N'Indonesia');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2280', N'PT. PROCTER & GAMBLE OPERATIONS INDONESIA', N'PT. P&G Ops Indonesia', N'Jakarta', N'ID', N'Indonesia');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'295', N'PROCTER & GAMBLE COLOMBIA LTDA.', N'P&G Colombia Ltda.', N'Bogota', N'CO', N'Colombia');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'818', N'PROCTER & GAMBLE INDUSTRIAL COLOMBIA LTDA.', N'P&G Indust Colombia Ltda.', N'Medellin', N'CO', N'Colombia');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2162', N'PROCTER & GAMBLE INDUSTRIAL, S.A.', N'P&G Industrial, S.A.', N'Caracas', N'VE', N'Venezuela ');
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2167', N'PROCTER & GAMBLE DE VENEZUELA, S.C.A.', N'P&G de Venezuela, S.C.A.', N'Caracas', N'VE', N'Venezuela ');


--insert city
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Anqing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'An''shan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Anyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Baoji');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Baotou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Beihai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Beijing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Bengbu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Benxi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Cangzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Changchun');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Changsha');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Changzhi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Chengde');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Chengdu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Chenzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Chifeng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Chongqing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dali');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dalian');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dandong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Daqing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Datong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dezhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dongguan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Dongying');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Foshan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Fushun');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Fuxin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Fuyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Fuzhou, Fujian');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Fuzhou, Jiangxi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Ganzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Gaoyao');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Guangxi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Guangzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Guilin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Hainaer');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Handan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Hangzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Hanzhong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Harbin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Hefei');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Huai''an');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Huaihua');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Huanggang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Huhehaote');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jiamusi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jiaxing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Ji''lin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jinan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jining');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jinjiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jinzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Jiujiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'JiuQuan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Kaifeng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Kunming');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Kunshan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Langfang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Lanzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Leshan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Lianyungang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Liaocheng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Linfen');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Linyi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Liuzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Longyan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Luoyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Maoming');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Meizhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Mianyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Mudanjiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanchang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanchong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanjing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanning');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanping');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nantong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Nanyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Neijiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Ningbo');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Panjin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Panzhihua');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Pingliang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Puning');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Putian');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Puyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Qingdao');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'QingYuan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Qinhuangdao');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Qiqihaer');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Quanzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Qujing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Rizhao');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shanghai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shangqiu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shantou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shaoguan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shaoxing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shenyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shenzhen');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shijiazhuang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shiyan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Shunde');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Simao');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Siping');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Songyuan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Suzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Tai''an');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Taicang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Taiyuan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Taizhou, Zhejiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Taizhou, Jiangsu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Tangshan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Tianjin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Tibet');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Tongren');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wanxian');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Weifang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Weihai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wenlin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wenzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wuhai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wuhan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wuhu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wulumuqi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Wuxi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xiamen');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xi''an');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xiangfan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xiangtan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xiaogan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xichang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xingtai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xining');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xinxiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xinyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xuancheng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Xuzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yanan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yancheng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yangzhou');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yantai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yibin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yichang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yinchuan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'YiWu');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yiyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yueyang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yulin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'YunCheng');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Yuxi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zaozhuang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhangzhou, Fujian');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhanjiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhaoqing');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhengzhou, Henan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhenjiang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhongshan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zhuhai');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zibo');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zigong');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CN', N'China', N'Zunyi');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'RO', N'Bulgaria', N'Sofia');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'RO', N'Romania', N'Bucharest');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'RO', N'Romania', N'Timisoara');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'RO', N'Romania', N'Urlati');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'RO', N'Serbia & Montenegro', N'Objekat');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PH', N'Philippines', N'Metro Manila');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Jakarta');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Karawang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Medan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Pekanbaru');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Palembang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Lampung');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Bandung');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Semarang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Yogyakarta');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Surabaya');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Malang');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Makassar');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Manado');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Balikpapan');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Banjarmasin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Pontianak');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ID', N'Indonesia', N'Denpasar');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'VE', N'Venezuela', N'Caracas');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'VE', N'Venezuela', N'Barquisimeto');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'VE', N'Venezuela', N'Guatire');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'VE', N'Venezuela', N'Valencia');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CO', N'Colombia', N'Medellin');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CO', N'Colombia', N'Rionegro');
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CO', N'Colombia', N'Bogota');


--insert site 
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'2792', N'BEIJING PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'4479', N'Beijing TC P&G Tech. Ltd');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'6093', N'BEIJING OFFICE');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'A747', N'CHAOYANG DISTRICT OFFICE');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'2793', N'CHENGDU PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'6511', N'CHENGDU OFFICE');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7803', N'DONG GUAN PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'1876', N'HUANGPU PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'3966', N'GUANGZHOU DC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'6670', N'GUANGZHOU GO');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7539', N'GUANGZHOU INNOVATION CENTER');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'A869', N'Luogang Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'B035', N'Guangzhou Innovation Center');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7807', N'MINHANG PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'5000', N'SHANGHAI-TRNG CTR/BEAUTY SALON');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7337', N'SHANGHAI OFC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7811', N'SHANGHAI PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'7812', N'SHANGHAI SALES OFFICE');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'A824', N'Shanghai South Ling Yan Office');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'A523', N'TAICANG PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'1744', N'XIQING PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'2798', N'TIANJIN PLANT');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'4947', N'Tianjin RDC (TJ Mfg Ltd)');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN01', N'Changsha RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN02', N'Lanzhou RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN03', N'Nanjing RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN04', N'Shanghai RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN05', N'Shenyang RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN06', N'Shenzhen RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CN', N'China', N'CN07', N'Xi''an RDC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PH', N'Philippines', N'4386', N'Ayala Center - Office (GO)');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PH', N'Philippines', N'4350', N'Petron Megaplaza - GBS Ctr (24F)');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PH', N'Philippines', N'3228', N'Cabuyao Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'0195', N'JAKARTA GENERAL OFFICE');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID01', N'Jakarta Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID02', N'PPT Medan');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID03', N'PPT Pekanbaru');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID04', N'BSS Palembang');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID05', N'BSS Lampung');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID06', N'TMW Bandung');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID07', N'TMW Semarang');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID08', N'TMW Yogyakarta');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID09', N'BCP Surabaya');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID10', N'BCP Malang');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID11', N'BCP Makassar');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID12', N'BCP Manado');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID13', N'LTA Balikpapan');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID14', N'LTA Banjarmasin');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID15', N'PU Pontianak');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ID', N'Indonesia', N'ID16', N'BCP Denpasar');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'VE', N'Venezuela ', N'5818', N'Caracas - GO');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'VE', N'Venezuela ', N'2033', N'Barquisimeto - Plant/Warehouse');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'VE', N'Venezuela ', N'2075', N'Guatire - Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'VE', N'Venezuela ', N'3360', N'Clover DC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CO', N'Colombia', N'2531', N'Medellin - Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CO', N'Colombia', N'A653', N'Rionegro DC');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CO', N'Colombia', N'4624', N'Bogota General Office');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Bulgaria', N'0171', N'Sofia GO');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'5152', N'Bucharest GO Novo Parc');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'RB01', N'Bucharest, Romania GO');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'0262', N'Dunca Logistic Park - Office');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'RT01', N'Dunca Logistic Park - Warehouse');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'RT02', N'Timisoara - Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Romania', N'A155', N'Urlati Plant');
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'RO', N'Serbia & Montenegro', N'SM01', N'Serbia & Montenegro Office');
